﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="cs443DataSet" targetNamespace="http://tempuri.org/cs443DataSet.xsd" xmlns:mstns="http://tempuri.org/cs443DataSet.xsd" xmlns="http://tempuri.org/cs443DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="MySqlConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MySqlConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.MySqlConnectionString.ConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="reportTableAdapter" GeneratorDataComponentClassName="reportTableAdapter" Name="report" UserDataComponentName="reportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MySqlConnectionString (Web.config)" DbObjectName="cs443.report" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT `booking_id`, `car_id`, `plate_no`, `brand`, `make`, `license_no`, `first_name`, `last_name`, `start_date`, `return_date`, `tariff`,  `type`, `cost`, `total_amout` FROM `cs443`.`report`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="booking_id" DataSetColumn="booking_id" />
              <Mapping SourceColumn="car_id" DataSetColumn="car_id" />
              <Mapping SourceColumn="plate_no" DataSetColumn="plate_no" />
              <Mapping SourceColumn="brand" DataSetColumn="brand" />
              <Mapping SourceColumn="make" DataSetColumn="make" />
              <Mapping SourceColumn="license_no" DataSetColumn="license_no" />
              <Mapping SourceColumn="first_name" DataSetColumn="first_name" />
              <Mapping SourceColumn="last_name" DataSetColumn="last_name" />
              <Mapping SourceColumn="start_date" DataSetColumn="start_date" />
              <Mapping SourceColumn="return_date" DataSetColumn="return_date" />
              <Mapping SourceColumn="tariff" DataSetColumn="tariff" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="cost" DataSetColumn="cost" />
              <Mapping SourceColumn="total_amout" DataSetColumn="total_amout" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="cs443DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="False" msprop:Generator_DataSetName="cs443DataSet" msprop:Generator_UserDSName="cs443DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="report" msprop:Generator_TableClassName="reportDataTable" msprop:Generator_TableVarName="tablereport" msprop:Generator_TablePropName="report" msprop:Generator_RowDeletingName="reportRowDeleting" msprop:Generator_UserTableName="report" msprop:Generator_RowChangingName="reportRowChanging" msprop:Generator_RowEvHandlerName="reportRowChangeEventHandler" msprop:Generator_RowDeletedName="reportRowDeleted" msprop:Generator_RowEvArgName="reportRowChangeEvent" msprop:Generator_RowChangedName="reportRowChanged" msprop:Generator_RowClassName="reportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="booking_id" msprop:Generator_ColumnVarNameInTable="columnbooking_id" msprop:Generator_ColumnPropNameInRow="booking_id" msprop:Generator_ColumnPropNameInTable="booking_idColumn" msprop:Generator_UserColumnName="booking_id" type="xs:unsignedInt" />
              <xs:element name="car_id" msprop:Generator_ColumnVarNameInTable="columncar_id" msprop:Generator_ColumnPropNameInRow="car_id" msprop:Generator_ColumnPropNameInTable="car_idColumn" msprop:Generator_UserColumnName="car_id" type="xs:unsignedShort" />
              <xs:element name="plate_no" msprop:Generator_ColumnVarNameInTable="columnplate_no" msprop:Generator_ColumnPropNameInRow="plate_no" msprop:Generator_ColumnPropNameInTable="plate_noColumn" msprop:Generator_UserColumnName="plate_no">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="brand" msprop:Generator_ColumnVarNameInTable="columnbrand" msprop:Generator_ColumnPropNameInRow="brand" msprop:Generator_ColumnPropNameInTable="brandColumn" msprop:Generator_UserColumnName="brand">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="make" msprop:Generator_ColumnVarNameInTable="columnmake" msprop:Generator_ColumnPropNameInRow="make" msprop:Generator_ColumnPropNameInTable="makeColumn" msprop:Generator_UserColumnName="make">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="license_no" msprop:Generator_ColumnVarNameInTable="columnlicense_no" msprop:Generator_ColumnPropNameInRow="license_no" msprop:Generator_ColumnPropNameInTable="license_noColumn" msprop:Generator_UserColumnName="license_no">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="first_name" msprop:Generator_ColumnVarNameInTable="columnfirst_name" msprop:Generator_ColumnPropNameInRow="first_name" msprop:Generator_ColumnPropNameInTable="first_nameColumn" msprop:Generator_UserColumnName="first_name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="last_name" msprop:Generator_ColumnVarNameInTable="columnlast_name" msprop:Generator_ColumnPropNameInRow="last_name" msprop:Generator_ColumnPropNameInTable="last_nameColumn" msprop:Generator_UserColumnName="last_name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="start_date" msprop:Generator_ColumnVarNameInTable="columnstart_date" msprop:Generator_ColumnPropNameInRow="start_date" msprop:Generator_ColumnPropNameInTable="start_dateColumn" msprop:Generator_UserColumnName="start_date" type="xs:dateTime" />
              <xs:element name="return_date" msprop:Generator_ColumnVarNameInTable="columnreturn_date" msprop:Generator_ColumnPropNameInRow="return_date" msprop:Generator_ColumnPropNameInTable="return_dateColumn" msprop:Generator_UserColumnName="return_date" type="xs:dateTime" />
              <xs:element name="tariff" msprop:Generator_ColumnVarNameInTable="columntariff" msprop:Generator_ColumnPropNameInRow="tariff" msprop:Generator_ColumnPropNameInTable="tariffColumn" msprop:Generator_UserColumnName="tariff" type="xs:float" />
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cost" msprop:Generator_ColumnVarNameInTable="columncost" msprop:Generator_ColumnPropNameInRow="cost" msprop:Generator_ColumnPropNameInTable="costColumn" msprop:Generator_UserColumnName="cost" type="xs:float" />
              <xs:element name="total_amout" msprop:Generator_ColumnVarNameInTable="columntotal_amout" msprop:Generator_ColumnPropNameInRow="total_amout" msprop:Generator_ColumnPropNameInTable="total_amoutColumn" msprop:Generator_UserColumnName="total_amout" type="xs:float" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:report" />
      <xs:field xpath="mstns:booking_id" />
      <xs:field xpath="mstns:plate_no" />
    </xs:unique>
  </xs:element>
</xs:schema>